package com.niit.mall.product.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.niit.mall.product.domain.po.Category;
import com.niit.mall.product.domain.vo.CategoryVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @BelongsProject: pardo_mall_backend
 * @BelongsPackage: com.niit.mall.product.mapper
 * @Author: ChuXuan
 * @CreateTime: 2025-06-08  01:16
 * @Description: 商品分类Mapper
 * @Version: 1.0
 */
@Mapper
public interface CategoryMapper extends BaseMapper<Category> {

    /**
     * 查询所有商品分类VO
     * @return 商品分类VO列表
     */
    @Select("select id, name from `pardo-product`.tb_category where is_deleted = 0")
    List<CategoryVO> queryCategoryVO();
}
